<?php

class m130815_085339_create_table_project extends CDbMigration
{
	public function up()
	{
        $this->createTable('tbl_project', array(
                                               'id' => 'pk',
                                               'name' => 'string NOT NULL',
                                               'description' => 'text NOT NULL',
                                               'create_time' => 'datetime DEFAULT NULL',
                                               'create_user_id' => 'int(11) DEFAULT NULL',
                                               'update_time' => 'datetime DEFAULT NULL',
                                               'update_user_id' => 'int(11) DEFAULT NULL',
                                          ));

    }

	public function down()
	{
        $this->dropTable('tbl_project');
    }

	/*
	// Use safeUp/safeDown to do migration with transaction
	public function safeUp()
	{
	}

	public function safeDown()
	{
	}
	*/
}